SELECT * FROM LOJA_NOTA_FISCAL WHERE CODIGO_FILIAL = '000010' AND NF_NUMERO = '012206'
SELECT * FROM LOJA_NOTA_FISCAL_IMPOSTO WHERE CODIGO_FILIAL = '000137' AND NF_NUMERO = '001050'
SELECT * FROM LOJA_NOTA_FISCAL_ITEM WHERE CODIGO_FILIAL = '000137' AND NF_NUMERO = '001050'


DELETE LOJA_NOTA_FISCAL WHERE CODIGO_FILIAL = '000010' AND NF_NUMERO = '012206'
DELETE LOJA_NOTA_FISCAL_IMPOSTO WHERE CODIGO_FILIAL = '000010' AND NF_NUMERO = '012206'
DELETE LOJA_NOTA_FISCAL_ITEM WHERE CODIGO_FILIAL = '000010' AND NF_NUMERO = '012206'


select * from loja_nota_fiscal where codigo_filial = '000146' and nf_numero = '000357'